Display or hide items in a PivotTable or PivotChart field

Hiding an item in a row field or column field removes it from the report, but the item still appears in the dropdown list for the field. Hiding an item in a page field removes it both from the report and from the dropdown list for the field.

Click the field. For a PivotChart report, click the field in its associated PivotTable report.
On the PivotTable toolbar, click PivotTable, and then click Sort and Top 10.
Under Top 10 AutoShow, click On.
In the Show box, click Top or Bottom, and in the box to the right, enter the number of items to display.
In the Using field box, click the data field to use to calculate the top or bottom items.

Click the arrow in the field.
Select the check box for each item that you want to show, and clear the check box for each item that you want to hide.
For fields that are organized in levels, click to list lower-level items so that you can display or hide them individually. The double-check indicates that some or all of the lower-level items are displayed, single-check indicates that only the checked item is displayed, and cleared indicates that neither the item nor its lower-level items are displayed.
To show or hide items that have no data, double-click the field, and then in the PivotTable Field dialog box, select or clear the Show items with no data check box. (Some types of source data don't support this option.)
For example, if there were no sales in April, you will see an item for April sales only if you show items with no data.

Double-click the page field.
If the Hide items box is present, select each item that you want to hide, and clear the selection from each item that you want to show.
If the Hide items box is missing, your source data always lists all available items in the dropdown list for the page field.
To show or hide items that have no data, select or clear the Show items with no data check box. (Some types of source data don't support this option.)
For example, if there were no sales in April, you will see an item for April sales only if you show items with no data.

Double-click the field.
In the PivotTable Field dialog box, click Advanced.
Under Top 10 AutoShow, click Off.
Click OK, and if the Hide items box is present and has items selected, clear selection from all such items.
If the field is a row (category) or column (series) field, click its arrow , and then click (Show All).

Note When you display or hide items in a PivotChart report or its associated PivotTable report, some chart formatting may be lost.

When calculating subtotals and grand totals in PivotTable reports, you can include or exclude the hidden items. On the PivotTable toolbar, click Include Hidden Items in Totals Button image . If this button is unavailable, your source data allows you to include or exclude hidden items in page fields: click PivotTable, click Table Options, and then select or clear the Subtotal hidden page items check box.